package com.theanh.RssActivity.db;

public class ItemTable {
	public static final String SQL_CREATE =
		"create table IF NOT EXISTS Item (ItemID integer primary key autoincrement, "
		+ "Title text not null, Description text, Url text not null, "
		+ "PublishDate long, Author text, ChannelID integer not null, "
		+ "Readed boolean default 0, ImageUrl text default '', "
		+ DbAdapter.constraintFK("FK_ChannelItem", ItemTable.CHANNEL_ID, ChannelTable.TABLE_NAME, ChannelTable.ID)
		+ ");";
	public static final String TABLE_NAME = "Item";
	
	public static final String ID = "ItemID";
	public static final String TITLE = "Title";
	public static final String DESCRIPTION = "Description";
	public static final String URL = "Url";
	public static final String PUBLISH_DATE = "PublishDate";
	public static final String AUTHOR = "Author";
	public static final String CHANNEL_ID = "ChannelID";
	public static final String READED = "Readed";
	public static final String IMAGE_URL = "ImageUrl";
	
	public static final String[] CULUMNS = new String[]{ ID, TITLE, DESCRIPTION, URL, PUBLISH_DATE, AUTHOR, CHANNEL_ID, READED, IMAGE_URL};
}
